create table qrtz_cron_triggers
(
    sched_name      nvarchar(120) not null,
    trigger_name    nvarchar(200) not null,
    trigger_group   nvarchar(200) not null,
    cron_expression nvarchar(200) not null,
    time_zone_id    nvarchar(80),
    primary key (sched_name, trigger_name, trigger_group),
    constraint qrtz_cron_triggers_ibfk_1
        foreign key (sched_name, trigger_name, trigger_group) references qrtz_triggers
)
go

exec sp_addextendedproperty 'MS_Description', 'Cron类型的触发器表', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_cron_triggers'
go

exec sp_addextendedproperty 'MS_Description', '调度名称', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_cron_triggers', 'COLUMN',
     'sched_name'
go

exec sp_addextendedproperty 'MS_Description', 'qrtz_triggers表trigger_name的外键', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_cron_triggers', 'COLUMN', 'trigger_name'
go

exec sp_addextendedproperty 'MS_Description', 'qrtz_triggers表trigger_group的外键', 'SCHEMA', 'dbo', 'TABLE',
     'qrtz_cron_triggers', 'COLUMN', 'trigger_group'
go

exec sp_addextendedproperty 'MS_Description', 'cron表达式', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_cron_triggers', 'COLUMN',
     'cron_expression'
go

exec sp_addextendedproperty 'MS_Description', '时区', 'SCHEMA', 'dbo', 'TABLE', 'qrtz_cron_triggers', 'COLUMN',
     'time_zone_id'
go

INSERT INTO [ry-vue].dbo.qrtz_cron_triggers (sched_name, trigger_name, trigger_group, cron_expression, time_zone_id) VALUES (N'RuoyiScheduler', N'TASK_CLASS_NAME1', N'DEFAULT', N'0/10 * * * * ?', N'Asia/Shanghai');
INSERT INTO [ry-vue].dbo.qrtz_cron_triggers (sched_name, trigger_name, trigger_group, cron_expression, time_zone_id) VALUES (N'RuoyiScheduler', N'TASK_CLASS_NAME2', N'DEFAULT', N'0/15 * * * * ?', N'Asia/Shanghai');
INSERT INTO [ry-vue].dbo.qrtz_cron_triggers (sched_name, trigger_name, trigger_group, cron_expression, time_zone_id) VALUES (N'RuoyiScheduler', N'TASK_CLASS_NAME3', N'DEFAULT', N'0/20 * * * * ?', N'Asia/Shanghai');